/*
 Navicat Premium Data Transfer

 Source Server         : Oracle
 Source Server Type    : Oracle
 Source Server Version : 110200
 Source Host           : 127.0.0.1:1521
 Source Schema         : STUDENTS

 Target Server Type    : Oracle
 Target Server Version : 110200
 File Encoding         : 65001

 Date: 21/05/2022 01:06:17
*/


-- ----------------------------
-- Table structure for BSCORE
-- ----------------------------
DROP TABLE "STUDENTS"."BSCORE";
CREATE TABLE "STUDENTS"."BSCORE" (
  "_ID" NUMBER(10,0) NOT NULL,
  "NAME" VARCHAR2(255 BYTE),
  "TYPE" VARCHAR2(255 BYTE),
  "SCLASS" VARCHAR2(255 BYTE),
  "IDNO" VARCHAR2(255 BYTE),
  "EXAM" VARCHAR2(255 BYTE),
  "SCORE" VARCHAR2(255 BYTE),
  "TIME" VARCHAR2(255 BYTE)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of BSCORE
-- ----------------------------
INSERT INTO "STUDENTS"."BSCORE" VALUES ('103', '徐磊', '软件工程', '4班', '13200000000', '计算机组成原理', '88', '2021-12-22');
INSERT INTO "STUDENTS"."BSCORE" VALUES ('102', '12312', '312312', '3123', '12312', '3123', '123123', '12312');

-- ----------------------------
-- Table structure for CLASS
-- ----------------------------
DROP TABLE "STUDENTS"."CLASS";
CREATE TABLE "STUDENTS"."CLASS" (
  "_id" NUMBER(10,0),
  "tip" VARCHAR2(255 BYTE),
  "area" VARCHAR2(255 BYTE),
  "time" VARCHAR2(255 BYTE),
  "teacher" VARCHAR2(255 BYTE),
  "title" VARCHAR2(255 BYTE)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of CLASS
-- ----------------------------
INSERT INTO "STUDENTS"."CLASS" VALUES ('10', '学分课', '实验楼B', '1-11周 周二 第三大节', '测试教师1', 'Python程序设计');
INSERT INTO "STUDENTS"."CLASS" VALUES ('2', 'Normal', '实验楼', '1-12周 周四 第二大节', '测试教师3', 'JAVA EE');

-- ----------------------------
-- Table structure for DEPARTMENT
-- ----------------------------
DROP TABLE "STUDENTS"."DEPARTMENT";
CREATE TABLE "STUDENTS"."DEPARTMENT" (
  "_ID" NUMBER(10,0) NOT NULL,
  "TITLE" VARCHAR2(255 BYTE),
  "TYPE" VARCHAR2(255 BYTE),
  "TEACHER" VARCHAR2(255 BYTE)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of DEPARTMENT
-- ----------------------------
INSERT INTO "STUDENTS"."DEPARTMENT" VALUES ('100', '计算机院', '["软工","计算机科学","233"]', '测试教师1');
INSERT INTO "STUDENTS"."DEPARTMENT" VALUES ('102', '电子信息院', '["光电","电子信息工程","物联网"]', '测试教师2');
INSERT INTO "STUDENTS"."DEPARTMENT" VALUES ('103', '1234123', '["4123455","8"]', '132413244');

-- ----------------------------
-- Table structure for EXAM
-- ----------------------------
DROP TABLE "STUDENTS"."EXAM";
CREATE TABLE "STUDENTS"."EXAM" (
  "_ID" NUMBER NOT NULL,
  "TITLE" VARCHAR2(255 BYTE),
  "TIP" VARCHAR2(255 BYTE),
  "AREA" VARCHAR2(255 BYTE),
  "TIME" VARCHAR2(255 BYTE),
  "TEACHER" VARCHAR2(255 BYTE)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of EXAM
-- ----------------------------
INSERT INTO "STUDENTS"."EXAM" VALUES ('8', '计算机网络', '期末考试', '实验楼B 402教师', '第14周 周五 8:00-10:00', '监考老师1');
INSERT INTO "STUDENTS"."EXAM" VALUES ('2', '测试考试', '测试', '测试地点', '测试时间', '测试监考老师1');

-- ----------------------------
-- Table structure for SCORE
-- ----------------------------
DROP TABLE "STUDENTS"."SCORE";
CREATE TABLE "STUDENTS"."SCORE" (
  "_ID" NUMBER(10,0) NOT NULL,
  "NAME" VARCHAR2(255 BYTE),
  "TYPE" VARCHAR2(255 BYTE),
  "SCLASS" VARCHAR2(255 BYTE),
  "IDNO" VARCHAR2(255 BYTE),
  "EXAM" VARCHAR2(255 BYTE),
  "SCORE" VARCHAR2(255 BYTE),
  "TIME" VARCHAR2(255 BYTE)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of SCORE
-- ----------------------------
INSERT INTO "STUDENTS"."SCORE" VALUES ('103', '张玲', '软件工程', '1班', '3200000010', '计算机网络', '78', '2021-1-8');

-- ----------------------------
-- Table structure for absence
-- ----------------------------
DROP TABLE "STUDENTS"."absence";
CREATE TABLE "STUDENTS"."absence" (
  "name" NVARCHAR2(255),
  "type" NVARCHAR2(255),
  "Sclass" NVARCHAR2(255),
  "idNo" NVARCHAR2(255),
  "time" NVARCHAR2(255),
  "_id" NUMBER
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of absence
-- ----------------------------
INSERT INTO "STUDENTS"."absence" VALUES ('张涛', '软件工程', '2班', '320001000', '2022-1-23 16:04:52', '1');
INSERT INTO "STUDENTS"."absence" VALUES ('李华昀', '软件工程', '3班', '3200000000', '2022-5-12 10:00:12', '2');

-- ----------------------------
-- Table structure for status
-- ----------------------------
DROP TABLE "STUDENTS"."status";
CREATE TABLE "STUDENTS"."status" (
  "name" NVARCHAR2(255),
  "type" NVARCHAR2(255),
  "Sclass" NVARCHAR2(255),
  "Ptype" NVARCHAR2(255),
  "project" NVARCHAR2(255),
  "time" NVARCHAR2(255),
  "_id" NUMBER
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of status
-- ----------------------------
INSERT INTO "STUDENTS"."status" VALUES ('李颖', '软件工程', '4班', '违纪', '翻墙出校', '2022-3-17', '1');
INSERT INTO "STUDENTS"."status" VALUES ('李玥', '软件工程', '3班', '奖项', '服创省赛二等奖', '2022-4-13', '3');
INSERT INTO "STUDENTS"."status" VALUES ('吴馨月', '电子信息工程', '1班', '奖项', '“挑战杯”省二等奖', '2022-5-13', '4');
INSERT INTO "STUDENTS"."status" VALUES ('张继', '软件工程', '3班', '奖项', '蓝桥杯省赛二等奖', '2022-1-22', '2');
INSERT INTO "STUDENTS"."status" VALUES ('张玲', '软件工程', '1班', '奖项', '服创省赛一等奖', '2022-4-30', '6');

-- ----------------------------
-- Table structure for students
-- ----------------------------
DROP TABLE "STUDENTS"."students";
CREATE TABLE "STUDENTS"."students" (
  "_id" NUMBER(11,0) NOT NULL,
  "name" NVARCHAR2(255),
  "type" NVARCHAR2(255),
  "age" NVARCHAR2(255),
  "sex" NVARCHAR2(255),
  "idNo" NVARCHAR2(255) NOT NULL,
  "sclass" NVARCHAR2(255)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of students
-- ----------------------------
INSERT INTO "STUDENTS"."students" VALUES ('1', '王明轩', '软件工程', '22', '男', '32000010001000', '2班');
INSERT INTO "STUDENTS"."students" VALUES ('3', '张朗', '电子信息工程', '21', '男', '32000000001000', '1班');
INSERT INTO "STUDENTS"."students" VALUES ('2', '张继', '软件工程', '23', '男', '3200000010000', '3班');
INSERT INTO "STUDENTS"."students" VALUES ('4', '王明', '软件工程', '22', '男', '3200000100', '1班');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE "STUDENTS"."user";
CREATE TABLE "STUDENTS"."user" (
  "_id" NUMBER(20,0) NOT NULL,
  "username" NVARCHAR2(255) NOT NULL,
  "password" NVARCHAR2(255)
)
TABLESPACE "USERS"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO "STUDENTS"."user" VALUES ('1', '1234', '1234');
INSERT INTO "STUDENTS"."user" VALUES ('2', '12344', '1234');
INSERT INTO "STUDENTS"."user" VALUES ('6', '1111', '1111');
INSERT INTO "STUDENTS"."user" VALUES ('7', '123111', '111');
INSERT INTO "STUDENTS"."user" VALUES ('10', '123444', '11111');
INSERT INTO "STUDENTS"."user" VALUES ('15', '11111111', '1111');
INSERT INTO "STUDENTS"."user" VALUES ('17', 'test', 'test');
INSERT INTO "STUDENTS"."user" VALUES ('18', '123456', '456');
INSERT INTO "STUDENTS"."user" VALUES ('19', 'admin', 'admin');
INSERT INTO "STUDENTS"."user" VALUES ('100', 'admin2', 'admin2');

-- ----------------------------
-- Sequence structure for ABSENCE_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."ABSENCE_SEQ";
CREATE SEQUENCE "STUDENTS"."ABSENCE_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for BSCORE_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."BSCORE_SEQ";
CREATE SEQUENCE "STUDENTS"."BSCORE_SEQ" MINVALUE 100 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for CLASS_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."CLASS_SEQ";
CREATE SEQUENCE "STUDENTS"."CLASS_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for DEPT_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."DEPT_SEQ";
CREATE SEQUENCE "STUDENTS"."DEPT_SEQ" MINVALUE 100 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for EXAM_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."EXAM_SEQ";
CREATE SEQUENCE "STUDENTS"."EXAM_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SCORE_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."SCORE_SEQ";
CREATE SEQUENCE "STUDENTS"."SCORE_SEQ" MINVALUE 100 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for STATUS_ID_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."STATUS_ID_SEQ";
CREATE SEQUENCE "STUDENTS"."STATUS_ID_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for TEST_ID_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."TEST_ID_SEQ";
CREATE SEQUENCE "STUDENTS"."TEST_ID_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for USER_ID_SEQ
-- ----------------------------
DROP SEQUENCE "STUDENTS"."USER_ID_SEQ";
CREATE SEQUENCE "STUDENTS"."USER_ID_SEQ" MINVALUE 100 MAXVALUE 999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Primary Key structure for table BSCORE
-- ----------------------------
ALTER TABLE "STUDENTS"."BSCORE" ADD CONSTRAINT "SYS_C0011216" PRIMARY KEY ("_ID");

-- ----------------------------
-- Triggers structure for table BSCORE
-- ----------------------------
CREATE TRIGGER "STUDENTS"."BSCORE_SEQ" BEFORE INSERT ON "STUDENTS"."BSCORE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_ID" IS NULL) 
BEGIN
  SELECT BSCORE_SEQ.NEXTVAL
  INTO :NEW._ID
  FROM DUAL;
END;
/

-- ----------------------------
-- Triggers structure for table CLASS
-- ----------------------------
CREATE TRIGGER "STUDENTS"."CLASS_SEQ" BEFORE INSERT ON "STUDENTS"."CLASS" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_id" IS NULL) 
BEGIN
  SELECT CLASS_SEQ.NEXTVAL
  INTO :NEW."_id"
  FROM DUAL;
END;
/

-- ----------------------------
-- Primary Key structure for table DEPARTMENT
-- ----------------------------
ALTER TABLE "STUDENTS"."DEPARTMENT" ADD CONSTRAINT "SYS_C0011218" PRIMARY KEY ("_ID");

-- ----------------------------
-- Checks structure for table DEPARTMENT
-- ----------------------------
ALTER TABLE "STUDENTS"."DEPARTMENT" ADD CONSTRAINT "SYS_C0011217" CHECK ("_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table DEPARTMENT
-- ----------------------------
CREATE TRIGGER "STUDENTS"."DEPT_SEQ" BEFORE INSERT ON "STUDENTS"."DEPARTMENT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_ID" IS NULL) 
BEGIN
  SELECT DEPT_SEQ.NEXTVAL
  INTO :NEW._ID
  FROM DUAL;
END;
/

-- ----------------------------
-- Primary Key structure for table EXAM
-- ----------------------------
ALTER TABLE "STUDENTS"."EXAM" ADD CONSTRAINT "SYS_C0011214" PRIMARY KEY ("_ID");

-- ----------------------------
-- Triggers structure for table EXAM
-- ----------------------------
CREATE TRIGGER "STUDENTS"."EXAM_SEQ" BEFORE INSERT ON "STUDENTS"."EXAM" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_ID" IS NULL) 
BEGIN
  SELECT EXAM_SEQ.NEXTVAL
  INTO :NEW._ID
  FROM DUAL;
END;
/

-- ----------------------------
-- Primary Key structure for table SCORE
-- ----------------------------
ALTER TABLE "STUDENTS"."SCORE" ADD CONSTRAINT "SYS_C0011215" PRIMARY KEY ("_ID");

-- ----------------------------
-- Triggers structure for table SCORE
-- ----------------------------
CREATE TRIGGER "STUDENTS"."SCORE_SEQ" BEFORE INSERT ON "STUDENTS"."SCORE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_ID" IS NULL) 
BEGIN
  SELECT SCORE_SEQ.NEXTVAL
  INTO :NEW._ID
  FROM DUAL;
END;
/

-- ----------------------------
-- Triggers structure for table absence
-- ----------------------------
CREATE TRIGGER "STUDENTS"."ABSENCE_ID_SEQ" BEFORE INSERT ON "STUDENTS"."absence" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_id" IS NULL) 
BEGIN
  SELECT ABSENCE_SEQ.NEXTVAL
  INTO :NEW."_id"
  FROM DUAL;
END;
/

-- ----------------------------
-- Triggers structure for table status
-- ----------------------------
CREATE TRIGGER "STUDENTS"."STATUS_ID_SEQ" BEFORE INSERT ON "STUDENTS"."status" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_id" IS NULL) 
BEGIN
  SELECT STATUS_ID_SEQ.NEXTVAL
  INTO :NEW."_id"
  FROM DUAL;
END;
/

-- ----------------------------
-- Primary Key structure for table students
-- ----------------------------
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0010808" PRIMARY KEY ("_id", "idNo");

-- ----------------------------
-- Checks structure for table students
-- ----------------------------
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0010805" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0010806" CHECK ("idNo" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0011182" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0011183" CHECK ("idNo" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0011194" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."students" ADD CONSTRAINT "SYS_C0011195" CHECK ("idNo" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table students
-- ----------------------------
CREATE TRIGGER "STUDENTS"."TEST_ID_SEQ_TRG" BEFORE INSERT ON "STUDENTS"."students" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_id" IS NULL) 
BEGIN
  SELECT TEST_ID_SEQ.NEXTVAL
  INTO :NEW."_id"
  FROM DUAL;
END;
/

-- ----------------------------
-- Primary Key structure for table user
-- ----------------------------
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0010807" PRIMARY KEY ("_id");

-- ----------------------------
-- Checks structure for table user
-- ----------------------------
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0010803" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0010804" CHECK ("username" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0011184" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0011185" CHECK ("username" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0011196" CHECK ("_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "STUDENTS"."user" ADD CONSTRAINT "SYS_C0011197" CHECK ("username" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table user
-- ----------------------------
CREATE UNIQUE INDEX "STUDENTS"."username"
  ON "STUDENTS"."user" ("username" ASC)
  LOGGING
  TABLESPACE "USERS"
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Triggers structure for table user
-- ----------------------------
CREATE TRIGGER "STUDENTS"."USER_ID_SEQ_TRG" BEFORE INSERT ON "STUDENTS"."user" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (NEW."_id" IS NULL) 
BEGIN
  SELECT USER_ID_SEQ.NEXTVAL
  INTO :NEW."_id"
  FROM DUAL;
END;
/
